﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="后台管理.aspx.cs" Inherits="ks.后台管理" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
    <style>

        form div {
            padding:10px;

            width: 936px;
        }
        form {
            width:944px;
padding:20px 10px; margin:20px auto;

        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <br />
            &nbsp;<asp:Label ID="Label1" runat="server" Text="年份："></asp:Label>
            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
            <asp:Label ID="Label2" runat="server" Text="歌手："></asp:Label>
            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="查询" />
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:Label ID="Label3" runat="server" Text="Label"></asp:Label>
            <br />
&nbsp;&nbsp;
        </div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AutoGenerateEditButton="True" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" Height="367px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" Width="961px">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="年份" HeaderText="年份" SortExpression="年份" />
                <asp:BoundField DataField="年度排名" HeaderText="年度排名" SortExpression="年度排名" />
                <asp:BoundField DataField="歌曲名" HeaderText="歌曲名" SortExpression="歌曲名" />
                <asp:BoundField DataField="歌手" HeaderText="歌手" SortExpression="歌手" />
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F5F7FB" />
            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
            <SortedDescendingCellStyle BackColor="#E9EBEF" />
            <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MusicConnectionString5 %>" SelectCommand="SELECT [年份], [年度排名], [歌曲名], [歌手] FROM [风云音乐榜]"></asp:SqlDataSource>
    </form>
</body>
</html>
